if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_NhomHang_GetAll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_NhomHang_GetAll]
GO

CREATE PROCEDURE [sp_NhomHang_GetAll]
AS
	SELECT	A.ID,A.Ten,A.Ma_nganh_hang,B.Ten AS Ten_nganh_hang, 
			A.Thue,A.Chiet_khau,A.Ghi_chu,A.Ngay_cap_nhat_cuoi 
		FROM NhomHang A
		INNER JOIN NganhHang B ON A.Ma_nganh_hang = B.ID
